-- @author lixiyong01
-- @date 2023.12.12
-- 小文件压缩处理

set hive.exec.compress.intermediate=true;
set mapreduce.map.output.compress=true;
set hive.exec.compress.output=true;
set mapreduce.output.fileoutputformat.compress=true;
set hive.exec.dynamic.partition=true;
set hive.exec.dynamic.partition.mode=nostrict;

use hdp_lbg_supin_zplisting;
insert overwrite table app_dqc_checked_mid_result partition (dt)
select * from app_dqc_checked_mid_result
where dt='${#date(0,0,-1):yyyyMMdd#}';